OpenUtilities Substation Help

Index Table Editor

The Index Table Editor lets the user edit the Index Table.

Accessed from:

Manage Ribbon > Utilities Group

Setting	Description
Button Name and Dialog	When you select a button in the Button Name field and a dialog name in the Dialog field, the database columns for that button and dialog will appear.
New	Adds a new row to the Index table. Blank setting fields will appear for the new row.
Edit	To edit the displayed information, select the desired row and then select the Edit button. Editing (Setting) fields will appear for the selected row.
Delete	Removes the selected row from the Index table.
Up Arrow/Down Arrow	Allows you to move a selected row up or down in the list of rows (which affect the order in which the fields appear in the dialog).
Exchange	Switches the positions of two selected rows (hold down the <Ctrl> key to in order to select the second row).

Index Table

The Index Table (IndexTable) allows you to control fields to display and the types of filter to use in each dialog.

Setting	Description
ID	Determines the order in which the fields appear in the dialog. The lowest number is the first field to appear in the dialog.
Dialog_Title	Must match the dialog title in the button table which in turn tells the software which query to use.
Table_Name	You can take data from more than one table. In the Table_Name column, give the name of the table from which the data is coming.
Field_In_Database	The name of the field in the query.
Field_In_Filter	Determines if the field will be displayed as a filter field in the dialog (such as the upper part of the dialog, selection field, neither or both).
Filter_Type	Determines the type of filter that will be applied to that field. Text - Indicates the records will be filtered for all records with the user-entered text as any part of the field. This is typically used for a description field where there are too many different entries to easily display in a list format. Set - Creates a filter list that shows all possible entries that are available in the database for that field. Use this when the possible selections will fit in a manageable list. CSV - Used when multiple entries may be available for a part. For example a lug may accept 12, 14, or 16 gauge wire. The data could be entered into the database as 12,14,16. The software would create a list filter but it would see this as three possible entries instead of one and 12, 14 and 16 would appear as separate selections in the list. The user could select any one of them and the part would be included in the filter. Max/Min - Used when the user is expected to enter an actual value and all parts returned need to be above or below the user entered value. URL - Used to designate a hyperlink field.
Filter_Label	Used for the field name that will appear in the dialog.
Select_Label	Used for the field name that will appear in the dialog.